a: Cache ~
b: junk drawer
What: "In a previous posts, SQL Server pros Patrick O'Keefe and Richard Douglas provided some tips on managing the SQL Server plan cache . If the plan cache is like the junk drawer on the bottom of your filing cabinet that stores some usefully, but also a lot of infrequently used stuff, the buffer cache is like the workspace folder on your desktop. It's the folder that has become a memory bank for files that you need handy or have in progress, and don't want to go searching through drives to access through a more cumbersome path. "
Useful?
Writer: Patrick O'Keefe and Richard Douglas
LCC:
Where:
Date: Aug 29 2014 7:49 PM
#6160 Email metamia about this
No critique for this page.
Feel free to be the first
Feel free to be the first
Please review the linked page for context.
If you can think of something better than this,
please add it to the database